Tabela SickLeaveZusDoc

Definicja tabeli SickLeaveZusDoc

Name

SickLeaveZusDoc

Code

SickLeaveZusDoc

Comment

 


Lista kolumn tabeli SickLeaveZusDoc

Name

Code

SickLeaveZusDocId

SickLeaveZusDocId

SickLeaveId

SickLeaveId

Per_PersonID

Per_PersonID

ZusDocumentId

ZusDocumentId

ZusStatus

ZusStatus

DocumentState

DocumentState

DocumentSymbol

DocumentSymbol

DocumentOriginal

DocumentOriginal

DocumentDate

DocumentDate

DocumentElectroDate

DocumentElectroDate

DocumentSentDate

DocumentSentDate

DocumentSerial

DocumentSerial

DocumentNo

DocumentNo

AbsenceFrom

AbsenceFrom

AbsenceTo

AbsenceTo

HospitalFrom

HospitalFrom

HospitalTo

HospitalTo

PersonId

PersonId

LicenceNo

LicenceNo

DoctorFirstName

DoctorFirstName

DoctorLastName

DoctorLastName

CancelDocSerial

CancelDocSerial

CancelDocNo

CancelDocNo

LinkedDocSerial

LinkedDocSerial

LinkedDocNo

LinkedDocNo

DocumentCancelCode

DocumentCancelCode

DocumentCancelCodeId

DocumentCancelCodeId

DocumentMultipleNo

DocumentMultipleNo

DocumentBackInfo

DocumentBackInfo

DocumentCancelInfo

DocumentCancelInfo

DocumentXml

DocumentXml

Active

Active

NoticeToEmployer

NoticeToEmployer

NoticeToInsured

NoticeToInsured

UpoXml

UpoXml


Kolumna SickLeaveZusDocId tabeli SickLeaveZusDoc

Definicja kolumny SickLeaveZusDocId tabeli SickLeaveZusDoc

Name

SickLeaveZusDocId

Code

SickLeaveZusDocId

Data Type

NUMBER(10)

Mandatory

Yes

Comment

SickLeaveZusDocId


Kolumna SickLeaveId tabeli SickLeaveZusDoc

Definicja kolumny SickLeaveId tabeli SickLeaveZusDoc

Name

SickLeaveId

Code

SickLeaveId

Data Type

NUMBER(10)

Mandatory

Yes

Comment

id do sickleave


Kolumna Per_PersonID tabeli SickLeaveZusDoc

Definicja kolumny Per_PersonID tabeli SickLeaveZusDoc

Name

Per_PersonID

Code

Per_PersonID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna ZusDocumentId tabeli SickLeaveZusDoc

Definicja kolumny ZusDocumentId tabeli SickLeaveZusDoc

Name

ZusDocumentId

Code

ZusDocumentId

Data Type

VARCHAR2(30)

Mandatory

No

Comment

id dokumentu pobrany z ZUS


Kolumna ZusStatus tabeli SickLeaveZusDoc

Definicja kolumny ZusStatus tabeli SickLeaveZusDoc

Name

ZusStatus

Code

ZusStatus

Data Type

VARCHAR2(20)

Mandatory

No

Comment

status dokumentu z ZUS


Kolumna DocumentState tabeli SickLeaveZusDoc

Definicja kolumny DocumentState tabeli SickLeaveZusDoc

Name

DocumentState

Code

DocumentState

Data Type

VARCHAR2(1)

Mandatory

No

Comment

status dokumentu S


Kolumna DocumentSymbol tabeli SickLeaveZusDoc

Definicja kolumny DocumentSymbol tabeli SickLeaveZusDoc

Name

DocumentSymbol

Code

DocumentSymbol

Data Type

VARCHAR2(12)

Mandatory

No

Comment

symbol dokumentu ZLA/AZLA/UZLA


Kolumna DocumentOriginal tabeli SickLeaveZusDoc

Definicja kolumny DocumentOriginal tabeli SickLeaveZusDoc

Name

DocumentOriginal

Code

DocumentOriginal

Data Type

VARCHAR2(1)

Mandatory

No

Comment

oryginal/kopia - O/C


Kolumna DocumentDate tabeli SickLeaveZusDoc

Definicja kolumny DocumentDate tabeli SickLeaveZusDoc

Name

DocumentDate

Code

DocumentDate

Data Type

DATE

Mandatory

No

Comment

data wystawienia zwolnienia


Kolumna DocumentElectroDate tabeli SickLeaveZusDoc

Definicja kolumny DocumentElectroDate tabeli SickLeaveZusDoc

Name

DocumentElectroDate

Code

DocumentElectroDate

Data Type

DATE

Mandatory

No

Comment

data elektronizacji


Kolumna DocumentSentDate tabeli SickLeaveZusDoc

Definicja kolumny DocumentSentDate tabeli SickLeaveZusDoc

Name

DocumentSentDate

Code

DocumentSentDate

Data Type

DATE

Mandatory

No

Comment

data wyslania do ZUS


Kolumna DocumentSerial tabeli SickLeaveZusDoc

Definicja kolumny DocumentSerial tabeli SickLeaveZusDoc

Name

DocumentSerial

Code

DocumentSerial

Data Type

VARCHAR2(8)

Mandatory

No

Comment

seria zwolnienia


Kolumna DocumentNo tabeli SickLeaveZusDoc

Definicja kolumny DocumentNo tabeli SickLeaveZusDoc

Name

DocumentNo

Code

DocumentNo

Data Type

VARCHAR2(20)

Mandatory

No

Comment

numer zwolnienia


Kolumna AbsenceFrom tabeli SickLeaveZusDoc

Definicja kolumny AbsenceFrom tabeli SickLeaveZusDoc

Name

AbsenceFrom

Code

AbsenceFrom

Data Type

DATE

Mandatory

No

Comment

 


Kolumna AbsenceTo tabeli SickLeaveZusDoc

Definicja kolumny AbsenceTo tabeli SickLeaveZusDoc

Name

AbsenceTo

Code

AbsenceTo

Data Type

DATE

Mandatory

No

Comment

 


Kolumna HospitalFrom tabeli SickLeaveZusDoc

Definicja kolumny HospitalFrom tabeli SickLeaveZusDoc

Name

HospitalFrom

Code

HospitalFrom

Data Type

DATE

Mandatory

No

Comment

 


Kolumna HospitalTo tabeli SickLeaveZusDoc

Definicja kolumny HospitalTo tabeli SickLeaveZusDoc

Name

HospitalTo

Code

HospitalTo

Data Type

DATE

Mandatory

No

Comment

 


Kolumna PersonId tabeli SickLeaveZusDoc

Definicja kolumny PersonId tabeli SickLeaveZusDoc

Name

PersonId

Code

PersonId

Data Type

NUMBER(10)

Mandatory

No

Comment

id lekarza, FK do Personnel


Kolumna LicenceNo tabeli SickLeaveZusDoc

Definicja kolumny LicenceNo tabeli SickLeaveZusDoc

Name

LicenceNo

Code

LicenceNo

Data Type

VARCHAR2(20)

Mandatory

No

Comment

 


Kolumna DoctorFirstName tabeli SickLeaveZusDoc

Definicja kolumny DoctorFirstName tabeli SickLeaveZusDoc

Name

DoctorFirstName

Code

DoctorFirstName

Data Type

VARCHAR2(40)

Mandatory

No

Comment

 


Kolumna DoctorLastName tabeli SickLeaveZusDoc

Definicja kolumny DoctorLastName tabeli SickLeaveZusDoc

Name

DoctorLastName

Code

DoctorLastName

Data Type

VARCHAR2(40)

Mandatory

No

Comment

 


Kolumna CancelDocSerial tabeli SickLeaveZusDoc

Definicja kolumny CancelDocSerial tabeli SickLeaveZusDoc

Name

CancelDocSerial

Code

CancelDocSerial

Data Type

VARCHAR2(6)

Mandatory

No

Comment

seria anulowanego ZLA


Kolumna CancelDocNo tabeli SickLeaveZusDoc

Definicja kolumny CancelDocNo tabeli SickLeaveZusDoc

Name

CancelDocNo

Code

CancelDocNo

Data Type

VARCHAR2(20)

Mandatory

No

Comment

numer anulowanego ZLA


Kolumna LinkedDocSerial tabeli SickLeaveZusDoc

Definicja kolumny LinkedDocSerial tabeli SickLeaveZusDoc

Name

LinkedDocSerial

Code

LinkedDocSerial

Data Type

VARCHAR2(6)

Mandatory

No

Comment

seria powiazanego ZLA


Kolumna LinkedDocNo tabeli SickLeaveZusDoc

Definicja kolumny LinkedDocNo tabeli SickLeaveZusDoc

Name

LinkedDocNo

Code

LinkedDocNo

Data Type

VARCHAR2(20)

Mandatory

No

Comment

numer powiazanego ZLA


Kolumna DocumentCancelCode tabeli SickLeaveZusDoc

Definicja kolumny DocumentCancelCode tabeli SickLeaveZusDoc

Name

DocumentCancelCode

Code

DocumentCancelCode

Data Type

VARCHAR2(8)

Mandatory

No

Comment

 


Kolumna DocumentCancelCodeId tabeli SickLeaveZusDoc

Definicja kolumny DocumentCancelCodeId tabeli SickLeaveZusDoc

Name

DocumentCancelCodeId

Code

DocumentCancelCodeId

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna DocumentMultipleNo tabeli SickLeaveZusDoc

Definicja kolumny DocumentMultipleNo tabeli SickLeaveZusDoc

Name

DocumentMultipleNo

Code

DocumentMultipleNo

Data Type

NUMBER(10)

Mandatory

No

Comment

numer kolejny w bloku wielokrotnego w dokumencie


Kolumna DocumentBackInfo tabeli SickLeaveZusDoc

Definicja kolumny DocumentBackInfo tabeli SickLeaveZusDoc

Name

DocumentBackInfo

Code

DocumentBackInfo

Data Type

VARCHAR2(160)

Mandatory

No

Comment

opis przyczyny wstecznego wystawienia


Kolumna DocumentCancelInfo tabeli SickLeaveZusDoc

Definicja kolumny DocumentCancelInfo tabeli SickLeaveZusDoc

Name

DocumentCancelInfo

Code

DocumentCancelInfo

Data Type

VARCHAR2(160)

Mandatory

No

Comment

opis przyczyny anulowania lub uniewaznienia


Kolumna DocumentXml tabeli SickLeaveZusDoc

Definicja kolumny DocumentXml tabeli SickLeaveZusDoc

Name

DocumentXml

Code

DocumentXml

Data Type

CLOB

Mandatory

No

Comment

dokument w formacie XML


Kolumna Active tabeli SickLeaveZusDoc

Definicja kolumny Active tabeli SickLeaveZusDoc

Name

Active

Code

Active

Data Type

NUMBER(3)

Mandatory

No

Comment

 


Kolumna NoticeToEmployer tabeli SickLeaveZusDoc

Definicja kolumny NoticeToEmployer tabeli SickLeaveZusDoc

Name

NoticeToEmployer

Code

NoticeToEmployer

Data Type

NUMBER(3)

Mandatory

No

Comment

Czy wysylac info o anulowaniu do pracodawcy recznie


Kolumna NoticeToInsured tabeli SickLeaveZusDoc

Definicja kolumny NoticeToInsured tabeli SickLeaveZusDoc

Name

NoticeToInsured

Code

NoticeToInsured

Data Type

NUMBER(3)

Mandatory

No

Comment

Czy wysylac info o anulowaniu do ubezpieczonego recznie


Kolumna UpoXml tabeli SickLeaveZusDoc

Definicja kolumny UpoXml tabeli SickLeaveZusDoc

Name

UpoXml

Code

UpoXml

Data Type

CLOB

Mandatory

No

Comment

Elektroniczne potwierdzenie wyslania zaswiadczenia do ZUS


Lista kluczy tabeli SickLeaveZusDoc

Name

Code

Primary

Identifier_1

Identifier_1

X


Klucz Identifier_1 tabeli SickLeaveZusDoc

Definicja klucza Identifier_1 tabeli SickLeaveZusDoc

Name

Identifier_1

Code

Identifier_1

Primary

Yes

Comment